#!/usr/bin/env python
# -*- coding: utf-8 -*-

'''
DROP PROCEDURE dsfs
CREATE PROCEDURE dsfs()
BEGIN
DECLARE i int DEFAULT 1;
DECLARE uid int DEFAULT 2;
DECLARE us VARCHAR(500) DEFAULT 'test';
DECLARE e VARCHAR(200) DEFAULT '1181064165@qq.com';
DECLARE x VARCHAR(500) DEFAULT 'e10adc3949ba59abbe56e057f20f883e';
	while i<500
	DO
		set us = CONCAT('test',i);
		INSERT INTO pw_members(uid,username,password,email) VALUES(uid,us,x,e);
		set uid = uid+1;
		set i=i+1;
	end WHILE;
END;

CALL dsfs()

'''
